Conditionally format cells to red color if cell 4 rows to the left is not blank

David77

Board Regular
Joined
Jun 24, 2020
Messages
85
Office Version
365
Platform
Windows
Hello everybody,



I currently have the following list:







I want to create a formula (probably through conditional formatting i'd imagine), that basically says:



If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red background.



As you can see from my list, I currently have a list of data which is pulled from a hidden sheet in the background for cell rows A, B, C & D. However, while these update automatically (and very nicely so too!), the red row with a red background filling does unfortunately not.



Can anybody help me in solving this issue? I would greatly appreciate it! :)



Thank you so much everybody !



Best regards,

David
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Toadstool

Well-known Member
Joined
Mar 5, 2018
Messages
947
Office Version
2016
Platform
Windows
Hi David77,

Is this what you want?

Book1
ABCDE
117AX30166Pin 1.5x11mm (6pcs)4K3009649
118AX30190Shaft 5x18 (2pcs.)7K3002961
119AX30198Slipper Drive Gear Shaft 5x53.56K3004392
120Axle 5x35mm (2pcs.)12K3002985
121AX30385Diff Gasket 16x25x0.5mm (2pcs)3K3002992
122AX30392Bevel Gear Set (38/13)12K3003005
12320T Drive Gear5K3003739
124Input Shaft 5x29mm (2pcs)8K3009663
125AX30410Inner Slipper Plate10K3004408
126AX30411Outer Slipper Plate10K3004415
127AX30412Slipper pad 27x8x1mm10K3004422
128AX30413Slipper spring 8.5x12 165 lbs/in - Black (2pcs)5K3004439
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E117:E134Expression=A117<>""textNO
 

David77

Board Regular
Joined
Jun 24, 2020
Messages
85
Office Version
365
Platform
Windows
Hi David77,

Is this what you want?

Book1
ABCDE
117AX30166Pin 1.5x11mm (6pcs)4K3009649
118AX30190Shaft 5x18 (2pcs.)7K3002961
119AX30198Slipper Drive Gear Shaft 5x53.56K3004392
120Axle 5x35mm (2pcs.)12K3002985
121AX30385Diff Gasket 16x25x0.5mm (2pcs)3K3002992
122AX30392Bevel Gear Set (38/13)12K3003005
12320T Drive Gear5K3003739
124Input Shaft 5x29mm (2pcs)8K3009663
125AX30410Inner Slipper Plate10K3004408
126AX30411Outer Slipper Plate10K3004415
127AX30412Slipper pad 27x8x1mm10K3004422
128AX30413Slipper spring 8.5x12 165 lbs/in - Black (2pcs)5K3004439
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E117:E134Expression=A117<>""textNO
Awesome!!!

Thank you so much! Have a great day :)

Kind regards,
David
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,930
Messages
5,508,176
Members
408,669
Latest member
AgsikapAko

This Week's Hot Topics

Top