ExcelBanter - if statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if statements (https://www.excelbanter.com/excel-discussion-misc-queries/187403-if-statements.html)

Matt

if statements

I am trying to test to see if a cell is color filled, then if it is fill that
cell with a value divided by the number of colored cells in the row. i've
tried an isblank statemnt but keep getting stuck.

Gary''s Student

if statements

To test a cell for fill color see:

http://www.cpearson.com/excel/Colors.aspx
--
Gary''s Student - gsnu200786

"Matt" wrote:

I am trying to test to see if a cell is color filled, then if it is fill that
cell with a value divided by the number of colored cells in the row. i've
tried an isblank statemnt but keep getting stuck.

All times are GMT +1. The time now is 02:02 AM.