Strike out cell if condition is met
sebdd87
Posted messages
5
Status
Member
-
Elie_1702 Posted messages 2 Status Member -
Elie_1702 Posted messages 2 Status Member -
Hello everyone,
I would like that in my Excel table when I add a date in a column, the part of that row where the amounts are located appears crossed out.
I think I'll use the IF function to do this, but I don't know how to make the selected cells appear crossed out.
Thank you in advance.
I would like that in my Excel table when I add a date in a column, the part of that row where the amounts are located appears crossed out.
I think I'll use the IF function to do this, but I don't know how to make the selected cells appear crossed out.
Thank you in advance.
1 answer
-
Hello
Excel does not handle the possibility of strikethrough cells in conditional formatting, but you can shade them or change the color
example to adapt
Rows 2 to 100 filled from A to F, with dates in column G. G and empty before entering a date with the keyboard
select A2;G100
ribbon / home tab / Conditional Formatting icon and "new rule"
in the "use a formula..." window
enter the formula:
=$G2>0
click on format, format with for example under "fill style" and shading
be careful of the $ sign in front of G1 to shade the entire row
Best regards
--
The quality of the response mainly depends on the clarity of the question, thank you!
