Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for an entire row or column?
I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for an entire row or column?
Highlight row
Conditional formatting Change drop down to Formula Is =$A1=yourvalue ... and choose your font to be red This is assuming the first column is A Hope this helps. -- John C "quinnj" wrote: I would like to turn all cells a Fill color (e.g., Red) based on the value in the first column of that row. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for an entire row or column?
quinnj wrote:
I would like to turn all cells a Fill color (e.g., Red) based on the value in the first column of that row. Use an absolute reference for the column. For data in row 1 starting in column A: =IF($A1="your value",1,0) Copy across as needed. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for an entire row or column?
You don't need the IF statement... see my post above.
-- John C "Glenn" wrote: quinnj wrote: I would like to turn all cells a Fill color (e.g., Red) based on the value in the first column of that row. Use an absolute reference for the column. For data in row 1 starting in column A: =IF($A1="your value",1,0) Copy across as needed. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting for an entire row or column?
John C wrote:
You don't need the IF statement... see my post above. Realized that right after I sent mine...and saw yours! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use conditional formatting for an entire column? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on entire column | Excel Worksheet Functions | |||
Conditional Formatting Entire Row | Excel Discussion (Misc queries) | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
copying conditional formatting to an entire column | Excel Discussion (Misc queries) |