| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula to colourfill cells when condition met
I daily populate a sheet sent to me with answers (time & dates) of 1,2 or 3
star items, the 3 star items I manually fill with a certain colour. Is there any way of filling a row that contains a cell with 3 stars automatically with a designated colour. In this example colour filling the whole row because one of the cells contains *** 15-May bx3008 aaaaaaaaaaaa *** bbbbbbbbbbbbbbbb ccccccc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I condition format block of cells ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to condition format rows with empty cells ? | Excel Discussion (Misc queries) | |||
| How to only incld cells that meet set condition in an Excel calc? | Excel Worksheet Functions | |||
| How to colourfill a cell with more than 3 conditions? | Excel Discussion (Misc queries) | |||
| how do i colourfill validated cells ? | Excel Discussion (Misc queries) | |||
Threaded Mode
