Have you used conditional formatting before?
Select AC6 and then click on Conditional Formatting on Home tab
New Rule > "use a formula to determine which cells to format" > use this formula
=G6="£"
select required format or colour > OK
Have you used conditional formatting before?
Select AC6 and then click on Conditional Formatting on Home tab
New Rule > "use a formula to determine which cells to format" > use this formula
=G6="£"
select required format or colour > OK
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks