#1
|
|||
|
|||
Conditional Formatting
I have put together a simple spreadsheet and in one section i want to highlight values in four columns by filling the cell with colour to determine if the calculated value in either of those columns are higher or lower than a value in another reference column by changing the cell colour to red (higher) or Green (lower).
I have written the conditional formatting okay and it works on the first row of the sheet but when I use format painter to copy it to other cells the cell references and colour do not change their references they are still referencing the first cell in column S rather than the associated row. For example row 5 cell T5, U5, Z5, AA5 would still reference Cell S4 rather than S5. |
#2
|
|||
|
|||
Use PasteSpecial.ConditionalFormats. Or select the whole range you want to apply the conditional format to at start. And be sure you have absolute and relative reverences set properly (defining conditional formatting, the formula is written for topmost selected row, and the rule is copied down by excel like ordinary formula). Usually having row reference relative is enough.
|
#3
|
||||
|
||||
Hi and welcome
I adapted it for column T, same method applies to other columns You have to use a relative reference for the rows like $T4 not $T$4 You should also apply to the entire range Perhaps adapt your formula for error values in col S like =ISERROR($t4) and format as required
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
conditional formatting
Quote:
Regards Paul |
#5
|
||||
|
||||
You're welcome
In the future would you please avoid quoting entire posts? They are just clutter. Use Quick Reply instead. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Tags |
conditional formatting |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Formatting | Joanne | Excel | 8 | 01-28-2019 08:30 AM |
Conditional Formatting | solberg2004 | Excel | 2 | 01-27-2017 10:07 AM |
Help with if and conditional formatting | piper7971 | Excel | 11 | 06-10-2015 12:07 AM |
Conditional formatting | technofrank | Excel | 3 | 06-08-2015 03:15 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |