How can I use an IF statement to find out if the cell is shaded?

G

Guest

I am trying to use the IF statement to get find out if the adjacent cell is
been formatted -- shaded. For example, I have a list of products, so I can do
find and replace by only shading the sell. Now, I need to create another
column to give some notes on those shaded cells.

Any help will be greatly appreciated.

Cheers,

Pascual
 
J

JethroUK©

the IF function wont help (or any other function/formulae) - you need to
take a look at 'conditional formatting'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement - compare to coloured cell 7
How can I get a count of cells in a range that are shaded a certa. 3
if statement, change cell only if true 4
Conditional formatting row if cell value in certain column is even 1
Conditional Cell Shading (based on the shading of other cells) 2
Conditional Formatting A Cell Based on Another Cell's Value 1
Find colored cells in a worksheet 7
Entereing an age and if statement in the same cell 1

Top