View Single Post
 
Old 05-09-2019, 02:57 AM
Paul_ Paul_ is offline Windows 10 Office 2019
Novice
 
Join Date: May 2019
Posts: 2
Paul_ is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Windows dimensions 190429 BA.xlsm (30.5 KB, 1 views)
Reply With Quote