Conditional formatting issue

David77

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows
Hello everybody,

I currently have this overview of my stock:

1602749917628.png


I have some conditional formattings that highlights the Quantity ("Antal") with a red color if no data is entered for it's quantity and highlights it with a green color if you enter a number.

This is all good for me, but I want to extend it so it highlights not only the cell with the quantity data, but also the other 4 cells to the left of it (so location, enhed, beskrivelse & varenummer). I don't want the entire row to be highlighted all the way to column XYZ, but i would love for it to highlight the row for each respective line from column A to E.

I hope this makes sense, please let me know if you want me to elaborate

Can anybody help me in editing my conditional formatting?

Thanks! :)
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Trixterz

Board Regular
Joined
Aug 15, 2019
Messages
59
Just click the drop down arrow for the "Applies to" column in your Conditional Formatting window and select the columns you want to apply the formatting to or change the values to the formula posted below...

Excel Formula:
=A:E

Not sure what row you start and stop on...
 

Watch MrExcel Video

Forum statistics

Threads
1,114,032
Messages
5,545,625
Members
410,696
Latest member
JTrehan
Top