| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
I need some help and direction. If Blue77 appears in any row in Column A, I
would like to change the format of that row columns A:K to color blue and style bold. Here is what I am doing now. Select range A2:K2 Format Conditional Formatting Formula Is =$A$2=€¯Blue77€¯ Bold Blue Ok It works for that row but I am not sure how to get it for all the rows with the exception of row 1. Do you know? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Threaded Mode
