Excel Check if

[jokelie19]

Hello there , I want to find a way to check a test that i make

for i.e : Writing 10 Questions in Excel with 4 Answers and Check them with scripting.

Is there a way to check if a cell is colored so that i can return a value that colored and know the grade.

Thx

[water]

Welcome to Autoit and the forum!

Use th Interior Object to retrieve the color/colorindex of a cell:

$iColor = $oWorkbook.ActiveSheet.Range("A1").Interior.Color

returns the color of cell A1 of the active sheet.

https://msdn.microsoft.com/en-us/library/bb242318(v=office.12).aspx

Edited May 13, 2017 by water