Format the color font depending on the value of another cell
Closed
SADY1106
Posts
1
Registration date
Friday August 19, 2016
Status
Member
Last seen
August 19, 2016
-
Aug 19, 2016 at 06:09 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 19, 2016 at 07:30 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 19, 2016 at 07:30 PM
Related:
- Format the color font depending on the value of another cell
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Clear only the formatting from the selected cell (leaving the content) - Guide
- What is the default font style in wordpad - Guide
- Rj45 color - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 19, 2016 at 07:30 PM
Aug 19, 2016 at 07:30 PM
SADY1106, Good evening.
You can use a Conditional Formatting function.
Suppose your data: A1:C100
Select your data range A1:C100
Go to Conditional Format Menu
New Rule
Using Formula
1) Rule
Type --> $E1<>""
Choose --> Fill Color GREEN
OK
2) Rule
Type --> $E1=""
Choose --> Fill Color RED
OK
OK
Please, tell us if it worked for you.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You can use a Conditional Formatting function.
Suppose your data: A1:C100
Select your data range A1:C100
Go to Conditional Format Menu
New Rule
Using Formula
1) Rule
Type --> $E1<>""
Choose --> Fill Color GREEN
OK
2) Rule
Type --> $E1=""
Choose --> Fill Color RED
OK
OK
Please, tell us if it worked for you.
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
