Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Conditional Formatting Help Required - Change cell colour based on values of other cells
I have developed the logic I require, I just need some help in writing
the code to do it as I haven't used Excel for quite some time. Basically, I need the code to perform the following: Example: If Y2 or AA2 0 and Z2 = 0, I need to change the colour of cell Z2 to red. I need to perform this function not only on row 2, but on rows 2 to 5642 Any help will be much appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Conditional Formatting Help Required - Change cell colour based on values of other cells
go to the name box on the left of the formula bar and enter
2:5642 hit enter This should select rows 2:5642 with cell A2 as the activecell Do Format=Conditional Format Change the first dropdown from Cell Value Is to Fromula is. Put in this formula =AND(OR($Y20,$AA20),$Z2=0,IsNumber($Z2),or(isnum ber($Y2),isnumber($AA2))) select your format and OK out. -- Regards, Tom Ogilvy wrote in message ups.com... I have developed the logic I require, I just need some help in writing the code to do it as I haven't used Excel for quite some time. Basically, I need the code to perform the following: Example: If Y2 or AA2 0 and Z2 = 0, I need to change the colour of cell Z2 to red. I need to perform this function not only on row 2, but on rows 2 to 5642 Any help will be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change drop down list in one cell based on values in other cells | Excel Discussion (Misc queries) | |||
change tab colour when using conditional formatting in a cell | Excel Worksheet Functions | |||
Conditional formatting of adjacent cells based on text in cell | Excel Programming | |||
conditional formatting based on values of another cell | Excel Programming | |||
Change the colour of a bunch of cells, based on one cell. | Excel Programming |