Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have B column turn red on conditional formatting of E column:
if column E is over 5000 it is set to turn red. I would like the invoice
number in B column to turn red on this same condition. Not able to figure it out. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have B column turn red on conditional formatting of E column:
Apply CF on col B using "Formula Is",
fix the point to col E using the $ sign, something like this (with B2 active): =$E25000 Any good? hit YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "jsharper" wrote: if column E is over 5000 it is set to turn red. I would like the invoice number in B column to turn red on this same condition. Not able to figure it out. Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
have B column turn red on conditional formatting of E column:
select part of column B
with for instance B2 as your top cell use "formula is" in stead of "cell value is" in the dropdown =E25000 and set the format -- Greetings from New Zealand "jsharper" wrote in message ... if column E is over 5000 it is set to turn red. I would like the invoice number in B column to turn red on this same condition. Not able to figure it out. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting A Whole Column | Excel Discussion (Misc queries) | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
Column conditional formatting | Excel Discussion (Misc queries) | |||
column to column conditional formatting won't work, need formula | Excel Worksheet Functions |