Change font and background color of several cells based on result of a formula

  • Thread starter Thread starter Zenaida
  • Start date Start date
Z

Zenaida

I have a workbook that has 6 spreadsheets in it. The layout of all 6
spreadsheets is identical. The information they contain is different.

I cell W27 > T29 then I want the background color and font color for
cells V26:W29 to be ColorIndex 40. If the result is false, I don't
want any changes.

I know how to do conditional formatting but I don't see how it would
work with what I want to do.

Is there code I could use in the worksheet event?

Thanks for your time. :)
 
CF would easily work, select all sheets, select V26:W29 and use a formula of

=$W$27>$T$29

and format the colour to that colorindex.



--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Thanks for helping me get my brain out of "stuck" mode. I used your
formula with CF and it works perfect! Thanks again.
 
You must log in or register to reply here.

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

Change cell background color based on content that results from li 4
Change background color of cell based on vlookup in cell 1
How to filter rows data based on background color of individual cells 1
Change Color of cell 3
Auto font & background color??? 3
Checkbox to change background color, font color and remove/ add bo 1
Font color change if cell if null 2
Changing Cell Background Color based on data from another cell 2

Back
Top